select * from products where pro_name like '%color%ment%' or pro_des like '%color%ment%'union all select * from products where (pro_name like '%color%' or pro_des like '%color%') or(pro_name like '%ment%' or pro_des like '%ment%') and (pro_name not like '%color%ment%' or pro_des not like '%color%ment%')
Feather and Rhinestones Decorate Aqua Blue Headpieces
Lovely Tulle Side Clamp Rhinestones For Party
Light Blue Sweet Tulle Beading Feather Fascinator For Party
Light Blue Pearl Exclusive Taffeta and Organza Fascinator
Lovely Organza and Lace Fascinators For Party
Beautiful Pink Taffeta and Tulle Pearl Fascinators For Party
Popular Organza Pearl Multilayer Hair Combs For Party
Fashionable Yellow and Black Feather Tulle Women s Fascinators
Pretty Yellow Beading Feather Flower Women s Fascinators For Party
Rhinestones Lovely Tulle Hairpins Birdcage Veils
Green And Fresh Small Laurie Flowers Beading Fascinators For Party
Lovely Taffeta and Tulle Beading Women s Fascinators For Party
Fashionable Feather Ribbons Bridal Hat Headpiece
Exclusive Tulle/ Rhinestones Hand Made Flowers Hair Combs
New Style A Line Hand Made Flower and Beaded 2015 Dama Dresses in Multi Color
2016 New Style A Line Hand Made Flower and Beaded Dama Dresses in Multi Color
Pretty A Line Strapless Dama Dresses with Bowknot in Blue
New Style Ball Gown Sweetheart Floor Length Quinceanera Dresses
Unique Pick Ups and Appliques Quinceanera Gowns with Court Train
2017 Lovely Beaded Rainbow Colored Detachable Quinceanera Dress in Tulle
Taffeta One Shoulder Royal Blue Dama Quinceanera Dress with Pleat
Chiffon Light Pink One Shoulder Quinceanera Dama Dress with Ruches
Chiffon Light Yellow Dama Quince Dress with Hand Made Flowers
Halter Top Spring Green Knee-length Chiffon Dama Dress 2014
Wine Red One Shoulder Chiffon Knee-length Dama Dress for Cheap
Red V-neck Knee-length Quinceanera Dama Dress with Pleat in Satin
Wine Red Dama Quinceanera Dress with Straps in Chiffon and Satin
Apple Green V-neck Chiffon Quinceanera Dress for Dama with a Sash
Sweetheart Watermelon Dama Dress with Ruches and a Brush Train
Brown Mini-length Dama Dress with Spaghetti Straps in Chiffon